The basic Insert statement is. CREATE TABLE Customer ( ID int identity(1,1), CustomerName varchar(30), Address varchar(100), Phone varchar (100) ) INSERT INTO Customer (CustomerName, Address, Phone) How about you want to put or just copy some of the data from other table to this Customer Table? INSERT INTO Customer (CustomerName, Address, Phone) SELECT CustomerName, Address, … Continue reading How to Insert from other table that already exists